/*
 Navicat Premium Data Transfer

 Source Server         : MyDB
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : workorder

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 12/04/2022 10:52:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'root', '123');
COMMIT;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `question_id` int NOT NULL,
  `is_user` int DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES (1, 1, 1, '2022-04-06 09:56:22.717000', NULL);
INSERT INTO `comment` VALUES (2, 1, 1, '2022-04-06 09:58:04.279000', NULL);
INSERT INTO `comment` VALUES (3, 1, 1, '2022-04-06 09:59:07.500000', '9');
INSERT INTO `comment` VALUES (4, 2, 1, '2022-04-08 20:40:30.995000', '3');
INSERT INTO `comment` VALUES (5, 3, 1, '2022-04-08 21:03:03.413000', 'hahhaha');
INSERT INTO `comment` VALUES (6, 3, 0, '2022-04-12 10:28:55.170000', '大家好');
INSERT INTO `comment` VALUES (7, 4, 0, '2022-04-12 10:30:35.785000', '下周六');
INSERT INTO `comment` VALUES (8, 4, 0, '2022-04-12 10:31:11.850000', '由于疫情原因也可能推迟哦');
INSERT INTO `comment` VALUES (9, 5, 0, '2022-04-12 10:40:38.443000', '下个月1号');
INSERT INTO `comment` VALUES (10, 5, 1, '2022-04-12 10:41:01.318000', '好的呢');
INSERT INTO `comment` VALUES (11, 5, 1, '2022-04-12 10:41:45.516000', '辛苦客服');
COMMIT;

-- ----------------------------
-- Table structure for question
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `is_over` int DEFAULT '0',
  `create_time` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of question
-- ----------------------------
BEGIN;
INSERT INTO `question` VALUES (1, 1, '今天几点下班？', 1, '2022-04-06 09:56:10.082000');
INSERT INTO `question` VALUES (2, 1, '发工资', 1, '2022-04-08 20:40:18.381000');
INSERT INTO `question` VALUES (3, 1, '哈哈哈', 0, '2022-04-08 20:49:54.964000');
INSERT INTO `question` VALUES (4, 1, '什么时候可以出去团建？', 0, '2022-04-12 10:29:33.632000');
INSERT INTO `question` VALUES (5, 2, '啥时候发工资', 1, '2022-04-12 10:35:21.575000');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'ymt', '123');
INSERT INTO `user` VALUES (2, 'yyy', '123');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
